CDISC Builderâ„¢  2.1 - Installation Test Scripts - Findrel
The following documentation contains test scripts and expected results for validating the CDISC Builder Findrel tool.  Do the following to verify proper installation:
  • Start CDISC Builder application by double clicking on the desktop icon.
  • Perform each test by performing the steps specified by the instructions.  
  • Evaluate the results of each step by comparing them with results described in the Documentation column. 
Script Description Documentation
Source Data Type invalid path
Navigate to location with no SAS datasets
Path name that is longer than 200 characters
Use [...] path navigation

Instructions 1  
Data Sets List of datasets match what is in the selected path
Verify preview button with a separate PROC PRINT
Verify select all button toggle.
Verify CDISC button selection of all CDISC type datasets.
 
Instructions 2
Search Criteria Verify the add of removal of search criteria.
 
Instructions 3
Search button Verify the search applied on selected dataset. 
Verify though a separate datastep program.
Verify findings are listed in search results.
 
Instructions 4

Related Domain

Verify list of domains matches list in documentation.
If CDISC dataset is selected, related domain is defaulted.
Verify the assignment of related domain as shown in the assigned related domain.
 
Instructions 5

Output 

Verify default output file is findrel.html in the same path of Source Data.
Verify name that is long over 200 characters. Proper warning message is presented.
Verify the [...] returns the correct path
 
Instructions 6
OK/Cancel OK button applies all selected parameters.
Memory of all fields is retained.
Cancel does not apply logic.
 
Instructions 7
Save Code Program is saved with proper comments
Generated program is submitted and results verified
 
Instructions 8

Instructions 1
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. Create the following path if it does not already exist.
    c:\temp\findrel\input
    c:\temp\findrel\source
    c:\temp\findrel\output 

  3. Submit the following program:
    libname testlib 'c:\temp\findrel\input';
    data testlib.shoes;
    set sashelp.shoes;
    run;
    data testlib.company;
    set sashelp.company;
    run;
    data testlib.manage;
    set sashelp.manage;
    run;

  4. In FINDREL screen, input an invalid path such as:
    c:\invalidpath\invalidpath

  5. Hit enter or click "OK" button, the following message appears:
    The field (Source Data) contains non-existing directory.

  6. Input path that navigate to location with no SAS datasets.

  7. Click "OK" button, verify a warning message appears:
    The Data Sets list is empty.

  8. Create a temp directory named
    very long name very long name very long name very long name very long name very long name very long name very long name very long name very long name very long name very long name very long name very long name very long name

  9. Click on [...] button to select that path that is longer than 200 characters.

  10. Click "OK" button.

  11. There is a message as follow:
    WARNING: You cannot select a path longer than 200 characters using Select dialog. Please enter the path directly to the Source Data field.

  12. Input that long path manually and click OK button again, verify the warning message above no longer appears.

  13. Click [...] button next to Source Data field.

  14. A Select dialog box appears with OK and Cancel buttons.

  15. Navigate to a path that different from the old one and click Cancel.

  16. Nothing happens.

  17. Click [...] button again and select this path 'c:\temp\findrel\input'.

  18. Click OK button, verify the path in Source Data now is 'c:\temp\findrels\input'.

Instructions 2
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. In FINDREL screen, click [...] button next to Source Data field to select this path 'c:\temp\findrel\input'

  3. Verify the Data Sets list lists all datasets in this location:
    COMPANY
    MANAGER
    SHOES

  4. From the Data Sets list, select MANAGER dataset and click Preview button.  A report of MANAGER is created.

  5. Select more than one dataset such as COMPANY and MANAGER and click Preview button.  Verify the report now is including Index of Datasets and  Details of each Dataset.

  6. Select all datasets in Data Sets list by click Select All button.

  7. Click Select All button again, verify all datasets in list are deselected.

  8. Click CDISC button, verify no datasets is selected because these datasets are not in CDISC standard.

Instructions 3
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. In FINDREL screen, input 'test' value for Additional Criteria Search.

  3. Click Add button, the 'test' value is inserted into Search Criteria list.

  4. Select 'test' item in this list and click Remove button.  Verify that this item has removed from the list.

Instructions 4
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. In FINDREL screen, input 'sale' value for Additional Criteria Search and click Add button.

  3. Verify the 'sale' item is added to Search Criteria List.

  4. Select SHOES in Data Sets list and then click Search button.

  5. There is one item has been found that is SALES.

Instructions 5
Start the CDISC Builder application from the icon in desktop.

  1. Submit the following program:
    libname testlib 'c:\temp\findrel\input';
    data testlib.ae(label = "Adverse Event");
    set sashelp.shoes;
    run;
    data testlib.demog(label = "Demographics");
    set sashelp.company;
    run;
    data testlib.co(label = "Comments");
    set sashelp.manage;
    run;

  2. Select FINDREL icon from the CDISC Builder screen.

  3. In FINDREL screen, verify all domains name in Related Domains list match with ones in documentation as follow:
    AE - Adverse Events
    AU - Autopsy
    BM - Bone Mineral Density (BMD) Data
    BR - Biopsy
    CM - Concomitant Meds
    CO - Comments
    CP - Compliance
    DC - Disease Characteristics
    DM - Demographics
    DR - Disease Response
    DS - Disposition
    DV - Protocol Deviations
    DY - Diary Data
    EE - EEG
    EG - ECG
    EX - Exposure
    FH - Family History
    HU - Healthcare Resource Utilization
    IE - Inclusion / Exclusion
    IM - Imaging
    LB - Laboratory Data
    MB - Microbiology
    MH - Medical History
    ML - Meal Data
    NE - Neurological Exam
    OM - Organ Measurements
    PC - PK Concentration
    PE - Physical Exam
    PP - PK Parameters
    QS - Questionnaires
    SC - Subject Characteristics
    SE - Subject Elements
    SG - Surgery
    SK - Skin Test
    SL - Sleep (Polysomnography) Data
    SS - Signs and Symptoms
    ST - Stress (Exercise) Test Data
    SU - Substance Use
    SV - Subject Visits
    TA - Trial Arms
    TE - Trial Elements
    TI - Trial Inclusion/Exclusion Criteria
    TV - Trial Visits Trial
    VS - Vital Signs

  4. Select AE dataset in Data Sets list, verify the related domain 'AE - Adverse Events' is selected.

  5. Select DEMOG, the related domain now is 'DM - Demographics'.

  6. Repeat again with CO dataset, verify the related domain is changed to 'CO - Comments'.

  7. Input 'sale' value for Additional Criteria Search and click Add button.

  8. Verify the 'sale' item is added to Search Criteria List.

  9. Select SHOES in Data Sets list and then click Search button.

  10. There is one item has been found that is SALES.

  11. Assign related domain for this variable by selecting a domain name such as 'EX - Exposure' from Related Domain list and click Assign button.

Instructions 6
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. Delete value in Output field.  Click Cancel button to return CDISC Builder screen.

  3. Navigate to FINDREL screen again, verify default output file is findrel.html in the same path of Source Data.

  4. Click on [...] button next to Output field and select a path that is longer than 200 characters.  Verify a warning message appears as follow:
    WARNING: You cannot select a path longer than 200 characters using Select dialog. Please enter the path directly to the Output field.

Instructions 7
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. Input the following information for FINDREL screen:
    Source Data: c:\temp\findrel\input
    Data Sets: AE, SHOES.
    Output File: c:\temp\findrel\input\findrel.html

  3. Add 'sale' value for Search Criteria List.  Click Search button, verify there are two items displayed in Search Results.

  4. Click OK, verify a report named 'findrel.html' is generated at c:\temp\findrel\input that print the results have been searched.

  5. Click Cancel to close this screen.  From the CDISC Builder screen, select FINDREL again.

  6. Verify that Source Data, Related Domain and Output File contain the information of last time.

Instructions 8
Start the CDISC Builder application from the icon in desktop.

  1. Select FINDREL icon from the CDISC Builder screen.

  2. In FINDREL screen, input the following information:
    Source Data: c:\temp\cdisc\input
    Data Sets: COMPANY

  3. Click Save Code button, the Save Code screen is displayed with default values of Path is current directory and File name is 'findrel'.

  4. Click OK button, View Code screen shows the code of findrel macro call.

  5. Copy that code and submit it.  Verify it created a report of Finding related domain for COMPANY dataset.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009